home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
dropData.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
3KB
|
107 lines
/* RCSVER $Id: dropData.sql,v 1.1 1999-12-02 16:54:34-06 randy CURRENT $ *
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: dropData.sql
* Date: 12/02/1999
* memo: Randy Wood
* Description: Drop data from all data (non-config) tables. Data comes
* from farebox events (FBC files).
* Changes:
************************************************************************* */
/* Views */
drop view mrreconcile;
/* Moneyroom tables */
drop table acctdaytotals;
drop table adjustment;
drop table batch;
drop table batchtotals;
drop table cashboxtotals;
drop table mrcconvert;
drop table subbatch;
/* Other tables for convert */
drop table convexcp;
drop table loadok;
drop table tmpseq;
drop table cashboxloc;
drop table probehist;
/* Sequences for data */
drop sequence seq_convert;
drop sequence seq_cashbox_total;
drop sequence seq_batch_total;
drop sequence seq_acctday_total;
drop sequence seq_batch;
drop sequence seq_subbatch;
/* Closing/Reconciliation Tables */
drop table cashclose;
drop table close_batch;
drop table mrorphans;
drop table mrpend;
drop table prorphans;
drop table prpend;
/* Context tables */
drop table probe_context;
drop table operator_context;
drop table driver_context;
drop table fare_context;
/* These depend on mstrrec */
drop table alarmact;
drop table alarmclr;
drop table badcbid;
drop table bitstat;
drop table cbdoorc;
drop table cbdooro;
drop table cbdooru;
drop table cbinsert;
drop table cblatch;
drop table cbremov;
drop table cbunlatch;
drop table cmdinit;
drop table conpwrb;
drop table conpwre;
drop table cscrash;
drop table cscurcnt;
drop table cskeycnt;
drop table csposto;
drop table curacc;
drop table curstate;
drop table escapek;
drop table fareentr;
drop table fbconfig;
drop table fberror;
drop table fbpwrfal;
drop table fschng;
drop table invalsec;
drop table jcdoorc;
drop table jcdooro;
drop table probefail;
drop table probesucc;
drop table psettime;
drop table rtechng;
drop table sboveroff;
drop table sboveron;
drop table settime;
drop table shftend;
drop table shftrele;
drop table shftrels;
drop table shftstrt;
drop table staket;
drop table startup;
drop table supersec;
drop table wayevnt;
drop table wayissue;
drop table waysvc;
drop table wayvalpass;
/* Mstrrec table */
drop table mstrrec;
/* Convert table */
drop table convert;